const config = require('./config/config.json').development;
const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: config.host,
  user: config.username,
  password: config.password,
  database: config.database
});

connection.query('SHOW VARIABLES LIKE "character_set%"', (err, results) => {
  if (err) throw err;
  console.log('Character set variables:');
  results.forEach(row => console.log(row.Variable_name, row.Value));
  connection.end();
});